Re: Postgresql & ODBC - Mailing list pgsql-odbc

From Giuliano Gavazzi
Subject Re: Postgresql & ODBC
Date
Msg-id a05200f1fba60972a0f5f@[10.0.1.13]
Whole thread Raw
In response to Postgresql & ODBC  (Art Fore <afore@sonic.net>)
List pgsql-odbc
At 7:53 -0800 2003/01/30, Art Fore wrote:
>I went through the info on the documentation to setup ODBC for
>Postgresql, but when I use isql PostgresQL-test, I get a no connect
>error. Could someone tell me what I did wrong? The two ini files are
>below. I can connect with Rekall, but it does not use ODBC, it uses
>python script.
>
>odbc.ini
>
>[PostgreSQL]
>Description         = Test to Postgres
>Driver              = PostgreSQL
>Trace               = Yes
>TraceFile           = sql.log
>Database            = test
>Servername          = localhost
>UserName            =
>Password            =
>Port                = 5432
>Protocol            = 6.4
>ReadOnly            = No
>RowVersioning       = No
>ShowSystemTables    = No
>ShowOidColumn       = No
>FakeOidIndex        = No
>ConnSettings        =
>
>odbcinst.ini
>
>[PostgreSQL]
>Description    = PostgreSQL driver
>Driver    = /usr/lib/unixODBC/libodbcpsql.so
>Setup    = /usr/lib/unixODBC/libodbcpsqlS.so
>FileUsage    = 1
>

I do not know isql, but your odbc.ini does not contain the list of
datasources and the definition of the PostgresQL-test datasource
itself.

Giuliano

pgsql-odbc by date:

Previous
From: "Tambet Matiisen"
Date:
Subject: psqlodbc.dll crash
Next
From: Alain Picard
Date:
Subject: ODBC breaks COUNTS, SEQUENCES as of Postgresql 7.3